Which are the different services in SQL Server ? How do you manage them ?

Question

Amit Singh · Answer

Replication Service: SQL Server 2000 replication enables sites to 
maintain multiple copies of data on different computers, in order to 
improve overall system performance, while ensuring that all the 
different copies are kept synchronized.
DTS: By using DTS, you can build data warehouses and data marts in SQL 
Server by importing and transferring data from multiple heterogeneous 
sources interactively or automatically on a regularly scheduled basis.
Analysis Services: Analysis Services provides tools for analyzing the data stored in data warehouses and data marts.
Metadata services: SQL Server Meta Data Services provides a way to store
 and manage metadata about information systems and applications. This 
technology serves as a hub for data and component definitions, 
development and deployment models, reusable software components, and 
data warehousing descriptions.
Reporting services: used to generate reports from the data in the database

interview

Which are the different services in SQL Server ? How do you manage them ?

Amit Singh

Can you answer this question?

1 Answers

Liked By